<%-- 
    Document   : ViewOrders
    Created on : Mar 17, 2015, 11:48:22 PM
    Author     : user
--%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="com.uniq.db.ConnectionFactory"%>
<%@page import="java.sql.Connection"%>

<%@include file="AdminHeader.jsp" %>
        <table width='100%' cellspacing='1' cellpadding='1'>
            <tr>
            <th>Order Id</th>
            <th>Customer Name</th>
            <th>Product</th>
             <th>Quantity</th>
             <th>Price</th>
              <th>Delivery</th>
             </tr>
       <%
Connection con=ConnectionFactory.getConnection();
Statement s=con.createStatement();      
ResultSet rs=s.executeQuery("select * from iorder");
while(rs.next())
{
%>
<tr>
    <td align="center"><%=rs.getString("orderid")%></td>
    <td align="center"><%=rs.getString("customername")%></td>
    <td align="center">Product <%=rs.getString("product")%></td>
    <td align="center"><%=rs.getString("quantity")%></td>
    <td align="center"><%=rs.getString("price")%></td>
    <td align="center"><%=rs.getString("Delivery")%></td>
</tr>
             <%

}
%>

    </table>
    </body>
</html>
